How to Ignore Where clause

gompuok · #1 (**permalink**) 06-07-10, 02:56

Hi, It's me again.
I have a simple question which I cant figure out how to do it. Let say I have to pass a parameter called name to my sql query that looks like below;

Select * from users where name = ${name}

What i want is, If there is a name value passes, apply it, if not, return all the name (no filter).

Hope anyone can help me. Thank you very much in advance.

r937 · #2 (**permalink**) 06-07-10, 07:41

Quote:

Originally Posted by gompuok

What i want is, If there is a name value passes, apply it, if not, return all the name (no filter).

this is real easy, and it's not a mysql question

if there is a name value passed in, run this --

Code:

SELECT columns FROM users WHERE name = ${name}

if there is no name value passed in, run this --

Code:

SELECT columns FROM users

sathkum2281 · #3 (**permalink**) 06-18-10, 07:16

can try this, this will solve your problem.
SELECT * FROM users where if(LENGTH('${name}')>0,name = '${name}',name like '%')

Internet Services

Web Development

Digital Marketing

Consumer Tech