Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
10
Reply
is there any combination of 'in' and 'like' operator.
prince raj
Jun 11 2014 6:59 AM
1.1k
Reply
string shape = " 'round', ' pearl', 'oval', 'heart', 'princess' ";
// first query - select * from table1 where shape in (" + shapes + ")
// second query - select * from table1 where shape like '%Pear%'";
now i want to use 'like' parameter for all other shape.
in short how can i use combination of 'like' and 'in' operator.
Thanks in advance.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
10
)
Next Recommended Forum
status change "active" to "expiry" based on time in sqltable
SQL Query problem