For example, I have a table
------------------------------------------------ -----------
id | name
1 | abcde
2 | bcdef
##3 | cdefg-------------------------------------------------- Then the string I get now may be bcd or CBD. I need to find two pieces of data with IDs 1 and 2 based on these two characters. How should I write a sql regular statement? Thank you teacher for teaching
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
If you want to query the ID based on the name that is not written in full, you can use wildcards to achieve it