using SUBSTING() in WHERE CLAUSE
Posted: Fri Aug 08, 2003 3:35 pm
Hello,
I have a table
create table individuals values (id, fname, mname, lname, born, died)
i have a form that has input fields name, year, month , day with a boolean AND/ OR option.
the theory...to be able to query the data by fname or mname or lname or year or month or day
now for the nam part i have opted to use a FULLTEXT Index search
but can i do a SUBSTRING(Date,exp ) in a WHERE CLAUSE?
what other otpions i have?
Kendall
I have a table
create table individuals values (id, fname, mname, lname, born, died)
i have a form that has input fields name, year, month , day with a boolean AND/ OR option.
the theory...to be able to query the data by fname or mname or lname or year or month or day
now for the nam part i have opted to use a FULLTEXT Index search
but can i do a SUBSTRING(Date,exp ) in a WHERE CLAUSE?
what other otpions i have?
Kendall