Is this sql correct?

programming
1

Hey Guys,

Is this sql correct?

select * from top_categories where action != ‘sub_menu’ and action !=‘play_audio’ and action = ‘text’ and path like ‘001,%’ or path = ‘023’ and top_categories.purge = ‘false’ and text like ‘%search%’ or name like ‘%search%’

In english it should read:

“Select everything from top_categories where the action does not equal sub_menu or play_audio but does equal text and the path starts with 001 or is equal to 023 and purge equals false and the text contains the word search or the page name contains the word search”

lol…and breath :smiley:

I’m pretty sure its returning some wrong results because o the wway I’ve balanced/structured my query …can anyone se anything glaringly obvious?

Zaid