All Questions
Tagged with ignore-case sql
2
questions
2
votes
1
answer
4k
views
how to use ignore case in spring JPA @query?
I have query as below:
@Query("SELECT b FROM Brand b WHERE b.name1 LIKE %:name1% or b.name2 like %:name2%")
List<Brand> findSome(@Param("name1") String name1, @Param("name2") String name2);
I ...
202
votes
9
answers
521k
views
SQL- Ignore case while searching for a string
I have the following data in a Table
PriceOrderShipped
PriceOrderShippedInbound
PriceOrderShippedOutbound
In SQL I need to write a query which searches for a string in a table. While searching for a ...