Question:Which query will return values containing strings "Pizza", "Burger", or "Hotdog" in the database? 

A SELECT * FROM fiberbox WHERE field REGEXP 'Pizza|Burger|Hotdog'; 

B SELECT * FROM fiberbox WHERE field LIKE '%Pizza%' OR field LIKE '%Burger%' OR field LIKE '%Hotdog%'; 

C SELECT * FROM fiberbox WHERE field = '%Pizza%' OR field = '%Burger%' OR field = '%Hotdog%'; 

D SELECT * FROM fiberbox WHERE field = '?Pizza?' OR field = '?Burger?' OR field = '?Hotdog?'; 

+ Answer
+ Report
Total Preview: 1216

Copyright © 2024. Powered by Intellect Software Ltd