rahman
Reputation: 4948
sql function to query a Table based on searching a column for a substring
I googled this but couldn't find an easy answer:
I need to write a function that takes a substring as parameter and return those rows which have this substring in a certain column:
select * from myTable where myTable.someColumn contains @substring
appreciate your help thank you
Upvotes: 0
Views: 30
Answers (1)
bitmagier
Reputation: 720
you may use
where myTable.someColumn like '%?%'
with '@substring' as parameter.
Upvotes: 1
Related Questions
- In SQL, how to check if a string is the substring of any other string in the same table?
- PostgreSQL search lists of substrings in string column
- Search PostgreSQL column for substring
- PostgreSQL : evaluate a substring inside function
- SELECT * FROM table WHERE "substring" IN table_field?
- Using Table As Input to Query for Substrings
- Searching substring in PostgreSQL (part II)
- Searching substring in PostgreSQL
- Effectively query on column that includes a substring
- Find rows that have a field which is a substring of the search string