Ask Your Question
3

What is the process to write a query that performs a reverse search of column values in SQL?

asked 2021-04-28 11:00:00 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2022-01-20 14:00:00 +0000

scrum gravatar image

To write a query that performs a reverse search of column values in SQL, you can use the LIKE operator with the % wildcard character. The query will search for all rows where the specified column value contains the reverse search value. Here's an example of a query that performs a reverse search of a column called "name" for the value "John":

SELECT * FROM myTable WHERE name LIKE '%nhoJ%';

This query will return all rows where the "name" value contains "nhoJ", which is the reverse of "John".

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-04-28 11:00:00 +0000

Seen: 8 times

Last updated: Jan 20 '22