# Changing '"' char by '\`' in FunSQL and MySQL query

**URL:** https://discourse.julialang.org/t/changing-char-by-in-funsql-and-mysql-query/73589
**Category:** Data
**Created:** [December 24, 2021, 2:03pm UTC](https://discourse.julialang.org/t/changing-char-by-in-funsql-and-mysql-query/73589 "2021-12-24T14:03:06Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![cesarmarinhorj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/cesarmarinhorj/32/30948_2.png) [@cesarmarinhorj](https://discourse.julialang.org/u/cesarmarinhorj)
#### Post date: [December 24, 2021, 2:03pm UTC](https://discourse.julialang.org/t/changing-char-by-in-funsql-and-mysql-query/73589/1 "2021-12-24T14:03:06Z")

</div>

I am testing FunSQL (is amazing!!!)  
examples are in SQLite, ok, going to MySQL.

my simple query dont works, because of extras ‘"’ chars around field names. Ok, so made a function, that replace them, as:  
function changeChar(s::String)  
replace(s, ‘"’ =\> ‘`’)  
end  
and made it the last pipe in a query, like:

```
q = codigo |> Where(Get.ID_CODIGO .<= 100)
sql = render(q) |> String |> changeChar

```

and all is fine!

there is another way? like define the correct dialect as Mysql? something like that?  
thanks!

---

<div class="post-metadata">

### Author: ![xitology](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xitology/32/7570_2.png) [@xitology](https://discourse.julialang.org/u/xitology)
#### Post date: [December 24, 2021, 2:31pm UTC](https://discourse.julialang.org/t/changing-char-by-in-funsql-and-mysql-query/73589/2 "2021-12-24T14:31:26Z")

</div>

You can specify the dialect when you render the query:

```julia
render(q, dialect = :mysql)

```