I have a table: columns are as follows.
now user enter something say (700)
i want to use a query such that:
it only display:
Please help me
select * from table where min < 700 and max > 1300 , you can also use Between query
In the same vein as your examples above.. suppose that I have a list of names and I want to return all the records where name1 is found a field, then return all records where name2 is found in a field... and so on. I have a list of 375 names and I'm search a single field for the presence of their name.
I have a table with 2 columns as follows:
I want to select id's that has all codes a AND b AND c. Please help for sql command. thanks
ooopps, this should be the correct code for the query..
select * from tablename where locate('a', code, 1) <> 0 or locate('b', code, 1) <> 0 or locate('c', code, 1) <> 0
manoj kumar bardhan
query-select * from table1 where min=0 and max=1300
dont know sql
how can i Find a particular text from all tables in DB.
how can i replace MDH DHANIA POWDER with ABC DHANIA POWDER
SELECT * FROM `student` WHERE locate( 'john', name )
-in the above sql query ,only john is given right,
Suppose a column is as follows
aaa dd oii qq
bb ask jiasj sjd
sxd nj kkk
and i want to select record having both bb and ask as substring in the column'. what should i do,how is the query for that
Can you please help me with a query for the below condition:
To find the position at which the occurance of the string "on" appears the second time in the word "consultation"