int to string in MySQL

Question

Is it possible to do something like this  Essentially I want to cast a int into a string and used the string on a join  Pay attention to the  t1 id   select t2    from t1  join t2 on t2 url  site com path  t1 id  more   where t1 id  gt  9000

User · Answer

You can do this   select t2   from t1 join t2 on t2 url    site com path     CAST t1 id AS VARCHAR 10       more   where t1 id  gt  9000   Pay attention to CAST t1 id AS VARCHAR 10

User · Answer

If you have a column called  col1  which is int  you cast it to String like this   CONVERT col1 char    e g  this allows you to check an int value is containing another value  here 9  like this   CONVERT col1 char  LIKE   9

User · Answer

You could use CONCAT  and the numeric argument of it is converted to its equivalent binary string form   select t2    from t1 join t2  on t2 url CONCAT  site com path     t1 id     more   where t1 id  gt  9000

User · Answer

select t2    from t1 join t2 on t2 url  site com path      cast t1 id as varchar        more   where t1 id  gt  9000   Using concat like suggested is even better though

User · Answer

Try it using CONCAT  CONCAT  site com path        CAST t1 id AS CHAR 25          more

[mysql] int to string in MySQL

Examples related to mysql