[SOLVED] WHERE statement

[947740]

I do not know how to organize my query to get it to work.

I want it to always search for the Date part, but I want the name parts to be optional.  The following query is invalid (due to ( and )), but it might give you a better idea of what I am trying to do.

 

SELECT * FROM moneyin WHERE (LName LIKE '%%' OR FName LIKE '%%') AND Date BETWEEN 1248152400 and 1248757200

[xtopolis]

SELECT * FROM moneyin WHERE `Date` BETWEEN 1248152400 and 1248757200

 

That might work. BUT  Date is a reserved word, and you must enclose it in `backticks` in order for mysql to read it as a column name and not keyword.  You should change the name of the Date column.

 

You could later add name specifications:

 

SELECT * FROM moneyin WHERE (`Date` BETWEEN 1248152400 AND 1248757200) AND LName LIKE 'S%'

or something.. kinda like you have it, but different.