Submit a question to our community and get an answer from real people.
Submit

How to you exclude spaces, capital letters and punctuations from being input thru varchar in MySQL

Report as

If you want to remove punctuation through varchar in MySQL, firstly create a table that held all the punctuation you wanted to remove. If you wanted to do it purely in MySQL though, one way to make things neater can be explained in details at http://stackoverflow.com/questions/1818430/sql-server-how-do-you-remove-punctuation-from-a-field.

Helpful (1) Fun Thanks for voting Comments (1)
Report as
Thank you. I wasn't sure if I was explaining it correctly. This is exactly what I was looking for.
Report as
Add a comment...
Do you have an answer?
Answer this question...
Did you mean?
Login or Join the Community to answer
Popular Searches