Ive a problem with Dreamweaver and SQL query.
This query works:

SELECT *
FROM table
WHERE table.field1 LIKE %MMColParam%


But if i try to extend to two or more fields the WHERE function with OR, like the following query, i receive a syntax error!

SELECT *
FROM table
WHERE table.field1 LIKE %MMColParam% OR table.field2 LIKE %MMColParam%

Whats the right syntax format for this type of query?

Thanx a lot

Hi Davide,

Try the following syntax:

SELECT *
FROM table
WHERE (field1 LIKE '%Value%') OR (field2 LIKE '%Value%')

Replace Value with the actual value and make sure field1 and field2 exist in your table.


Georgi Kralev

----------------------------------
Support - www.DMXzone.com