1

I am generating the below query as part of our system:

SELECT * FROM (`videos`) WHERE (
    `videos`.`title` LIKE "%apple%" 
  OR WHERE 
    `videos`.`byline` LIKE "%apple%" 
  OR WHERE `videos`.`description` LIKE "%apple%"
);

However, this is throwing a syntax error.

So, what's up?

Note that I need the brackets as those three where's are linked, often followed by separate AND WHERE's

Kermit
  • 33,827
  • 13
  • 85
  • 121
Hailwood
  • 89,623
  • 107
  • 270
  • 423

3 Answers3

4

Sql statements use single quotes around literal values. Also only one where clause is needed in this case. Simply use one where clause and then use or to connect the predicates. The script also has some parenthesis that are not required.

The final result looks like:

SELECT * FROM `videos` WHERE
    `videos`.`title` LIKE '%apple%' OR 
    `videos`.`byline` LIKE '%apple%' OR 
    `videos`.`description` LIKE '%apple%';
Kevin Bowersox
  • 93,289
  • 19
  • 159
  • 189
0

is OR WHERE valid SQL? Try this:

SELECT * FROM (`videos`) WHERE (
    `videos`.`title` LIKE "%apple%" 
  OR  
    `videos`.`byline` LIKE "%apple%" 
  OR `videos`.`description` LIKE "%apple%"
);
pedak
  • 91
  • 3
0

Replace "OR WHERE" with "WHERE" and replace double quote with single quote " ---> '

andy
  • 5,979
  • 2
  • 27
  • 49