why should I use _ instead of * wildcard in "like"?

gordthompson / sqlalchemy-access

A Microsoft Access dialect for SQLAlchemy.

MIT License

50 stars 9 forks source link

why should I use _ instead of * wildcard in "like"? #24

Closed pnwork closed 4 months ago

pnwork commented 4 months ago

I noticed that inside of access db I can do ""select '21' like '2';" and it returns -1. If I do the same in jupyter notebook with sql alchemy, it returns "0". I found out that wildcard becomes underscore _ and I have to modify queries replacing with _ in jupyter notebook. Why is it so?